package org.example.excel;

/**
 * @className: mian
 * @description: [描述说明该类的功能]
 * @author: [姓名]
 * @version: [v1.0]
 * @createTime: [2023/9/20 16:09]
 * @updateUser: [姓名]
 * @updateTime: [2023/9/20 16:09]
 * @updateRemark: [描述说明本次修改内容]
 */
public class mian {
    public static void main(String[] args) {
        String path = "D:/testDemo/student.xlsx";
        String imageTargetPath = "D:/testDemo";
 
        ExcelUtil excelUtil = new ExcelUtil(path, imageTargetPath);
        ExcelSheet sheet = excelUtil.getSheet(0,1);


        System.out.println(sheet.getRowDataList());
//        List<Map<Integer, ExcelDataEntry>> rowDataList = sheet.getRowDataList();
//        String s = JSONObject.toJSONString(rowDataList);
//        System.out.println(s);
//        System.out.println("========================================1");
//        List<ExcelDataEntry> a = sheet.getDataByTitle("学号" );
//        System.out.println(a);
//        System.out.println("========================================2");
//        ExcelDataEntry c = sheet.getDataByTitle("学号" ,2);
//        System.out.println(c);
//        System.out.println("========================================3");
//        ExcelDataEntry d = sheet.getDataByTitle(1,"学号" ,2);
//        System.out.println(d);
//        System.out.println("========================================4");
//        List<Map<Object, ExcelDataEntry>> colDataList = sheet.getColDataList();
//        String colDataListString = JSONObject.toJSONString(colDataList);
//        System.out.println(colDataListString);
//        System.out.println("========================================5");
    }
 
//    public static void main(String[] args) {
//        String path = "F:\\desktop\\3.xls";
//        String imageTargetPath = "F:/testDemo/testExcel/image";
//
//        ExcelUtil excelUtil = new ExcelUtil(path, imageTargetPath);
//        ExcelSheet sheet = excelUtil.getSheet(0, null);
//        System.out.println(sheet.getRowDataList());
//    }
}